import pandas as pd
import numpy as np

def getColumns(dataFrame):
    columns = []
    for column in dataFrame.columns.to_list():
        columns.append(column[1])

    return columns

def getValues(dataFrame):
    values = []

    for value in dataFrame.values[0]:
        values.append(value)

    return values

df = pd.read_excel(r'C:\Users\Administrator\Desktop\test_blank.xlsx')

column = df['业务员']

value = df['收入']

res = pd.pivot_table(df,values='日期', columns=['收入'], aggfunc='sum')

res_columns = getColumns(res)
print(res_columns)

res_values = getValues(res)
print(res_values)


